package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_member_idcard;

//DAO
public interface T_member_idcardMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_MEMBER_IDCARD  WHERE ID = #{ID}")
	public ApiT_member_idcard findT_member_idcardById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM T_member_idcard")
	public List<ApiT_member_idcard> findT_member_idcards();

	// 添加
	public int insertT_member_idcard(ApiT_member_idcard t_member_idcard);

	// 修改
	@Update("UPDATE T_MEMBER_IDCARD SET USER_ID = #{user_id,jdbcType=INTEGER}, id_type = #{id_type,jdbcType=INTEGER}, NAME = #{name,jdbcType=VARCHAR}, ID_NO = #{id_no,jdbcType=VARCHAR}, ID_FRONT = #{id_front,jdbcType=VARCHAR}, ID_BACK = #{id_back,jdbcType=VARCHAR}, APPLY_TIME = #{apply_time,jdbcType=VARCHAR}, STATUS = #{status,jdbcType=INTEGER}, REASON = #{reason,jdbcType=VARCHAR}, UPDATE_TIME = #{update_time,jdbcType=VARCHAR}, EXT1 = #{ext1,jdbcType=VARCHAR}, EXT2 = #{ext2,jdbcType=VARCHAR}, EXT3 = #{ext3,jdbcType=VARCHAR}, EXT4 = #{ext4,jdbcType=VARCHAR}, EXT5 = #{ext5,jdbcType=VARCHAR}, APPLY_UID = #{apply_uid,jdbcType=INTEGER} WHERE ID = #{id}")
	public int updateT_member_idcard(ApiT_member_idcard t_member_idcard);

	// 删除
	@Delete("DELETE FROM T_MEMBER_IDCARD  WHERE ID = #{ID}")
	public int deleteT_member_idcard(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
